<?php

require_once '../mysqlConnect.php';

function retrievePhysicalSymptomQuestions () {
	
	$conn = GetPDOConnection();
	
	$sql = "SELECT * FROM physical_symptom_questions WHERE text != 'Record Date' ORDER BY qnumber";
	$STH = $conn->prepare($sql);
	$STH->setFetchMode(PDO::FETCH_ASSOC);
	$STH->execute();
	$symptoms = $STH->fetchAll();

	foreach ($symptoms as $key => $symptomInfo)
		$symptoms[$key]["answer_options"] = getDropDownOptions($symptomInfo['type_options']);
	
	$conn = null;
	return $symptoms;
}